SQL Server Reporting Services (SSRS) showed up to the party in SQL Server 2000. A really awesome tool for data delivery. Most SQL Server environments heavily leverage this powerful tool. Microsoft has baked in some excellent views and tables for report rendering information (dbo.ExecutionLog, dbo.ExecutionLog2 and dbo.ExecutionLog3). SSRS also supplies a text log with additional details for errors and warnings. All are useful when trouble shooting a failure or identifying report execution trends, but what happens if you want to know what is running, now?

Read more »